Top 3 Excel Formulas and Functions (Excel Training Book 0) by Andrei Besedin

Author:Andrei Besedin
Language: eng
Format: azw3, epub
Published: 2017-06-24T07:00:00+00:00

Vlookup

Vlookup is vertical lookup. Vlookup is used to find something from a vertical list or table. Suppose there are three sales rep. we want to know how much commission they will get If they achieve certain category.

VLOOKUP is an Excel function to look up and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.

Syntax

=VLOOKUP (value, table, col_index, [range_lookup])

Arguments

Value - The value to look for in the first column of a table.

Table - The table from which to retrieve a value.

Col_index - The column in the table from which to retrieve a value.

Range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.